package it.nola.soccer;

public class DbConst {
	public static final class actions {
		public static final String KEY_ROWID="_id";
		public static final String KEY_CRONACA="cronaca";
		public static final String KEY_TEAM="team";
		public static final String KEY_MIN="min";
		public static final String KEY_HALF="time";
		public static final String KEY_DESCRI="descri";
		public static final String NAME="actions";
		public static final String[] ALL_FIELDS=new String[] { KEY_ROWID, KEY_DESCRI, KEY_CRONACA,
				KEY_TEAM, KEY_MIN, KEY_HALF };
	}

	public static final class cards {
		public static final String KEY_ROWID="_id";
		public static final String KEY_PLAYER="player";
		public static final String KEY_CRONACA="cronaca";
		public static final String KEY_TEAM="team";
		public static final String KEY_MIN="min";
		public static final String KEY_HALF="time";
		public static final String KEY_REASON="reason";
		public static final String NAME="cards";
		public static final String[] ALL_FIELDS=new String[] { KEY_ROWID, KEY_PLAYER, KEY_CRONACA,
				KEY_TEAM, KEY_MIN, KEY_HALF, KEY_REASON };
	}

	public static final class cronache {
		public static final String KEY_TITLE="title";
		public static final String KEY_BODY="notes";
		public static final String KEY_TEAM1="team1";
		public static final String KEY_TEAM2="team2";
		public static final String KEY_REFEREE="referee";
		public static final String KEY_RESULT="result";
		public static final String KEY_ASSISTENT1="assistent1";
		public static final String KEY_ASSISTENT2="assistent2";
		public static final String KEY_MATCH_DATE="dm";
		public static final String KEY_ROWID="_id";
		public static final String KEY_PLACE="place";
		public static final String NAME="cronache";
		public static final String[] ALL_FIELDS=new String[] { KEY_ROWID, KEY_TITLE, KEY_BODY,
				KEY_TEAM1, KEY_TEAM2, KEY_REFEREE, KEY_ASSISTENT1, KEY_ASSISTENT2, KEY_MATCH_DATE,
				KEY_PLACE, KEY_RESULT };
	}

	public static final class goals {
		public static final String KEY_ROWID="_id";
		public static final String KEY_PLAYER="player";
		public static final String KEY_CRONACA="cronaca";
		public static final String KEY_TEAM="team";
		public static final String KEY_MIN="min";
		public static final String KEY_HALF="time";
		public static final String KEY_IS_AUTO="is_auto";
		public static final String KEY_NAME_PLAYER="name_player_goal";
		public static final String NAME="goals";
		public static final String[] ALL_FIELDS=new String[] { KEY_ROWID, KEY_PLAYER, KEY_CRONACA,
				KEY_TEAM, KEY_MIN, KEY_HALF, KEY_IS_AUTO };
	}

	public static final class players {
		public static final String KEY_ROWID="_id";
		public static final String KEY_CRONACA="cronaca";
		public static final String KEY_NR="nr";
		public static final String KEY_TEAM="team";
		public static final String KEY_NAME="name";
		public static final String NAME="players";
		public static final int MAX_NUMBER=19;
		public static final String[] ALL_FIELDS=new String[] { KEY_ROWID, KEY_NR, KEY_CRONACA,
				KEY_TEAM, KEY_NAME };
	}

	public static final class subst {
		public static final String KEY_ROWID="_id";
		public static final String KEY_PLAYER_IN="player_in";
		public static final String KEY_PLAYER_OUT="player_out";
		public static final String KEY_CRONACA="cronaca";
		public static final String KEY_TEAM="team";
		public static final String KEY_MIN="min";
		public static final String KEY_HALF="time";
		public static final String[] ALL_FIELDS=new String[] { KEY_ROWID, KEY_PLAYER_IN,
				KEY_CRONACA, KEY_TEAM, KEY_MIN, KEY_HALF, KEY_PLAYER_OUT };
		public static final String NAME="subst";
		public static final String KEY_NAME_PLAYER_IN="name_player_in";
		public static final String KEY_NAME_PLAYER_OUT="name_player_out";
		public static final String KEY_TEAM_SUBST="team_subst";
	}

	public static final String DATABASE_NAME="soccer_notes";
	public static final short[] HALFS=new short[] { 1, 2, 3, 4 };
	public static final Short HOME_TEAM=1;
	public static final Short FOREIGN_TEAM=2;
	public static final short[] TEAMS=new short[] { HOME_TEAM, FOREIGN_TEAM };

}
